{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='奇瑞')|(price['brand']=='路虎')|(price['brand']=='开瑞')|(price['brand']=='凯翼')|(price['brand']=='捷豹')|(price['brand']=='威麟')|(price['brand']=='捷途')|(price['brand']=='瑞麒')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['奇瑞捷豹路虎>>', '进口捷豹>>', '进口捷豹新能源>>', '凯翼', '开瑞>>', '开瑞新能源>>',\n",
       "       '进口路虎>>', '进口路虎新能源>>', '奇瑞汽车>>', '奇瑞新能源>>', '瑞麒', '威麟', '奇瑞捷豹路虎',\n",
       "       '捷豹', '开瑞', '路虎', '奇瑞汽车', '奇瑞新能源'], dtype=object)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price.factory.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='奇瑞')|(price['brand']=='路虎')|(price['brand']=='开瑞')|(price['brand']=='凯翼')|(price['brand']=='捷豹')|(price['brand']=='威麟')|(price['brand']=='捷途')|(price['brand']=='瑞麒')]\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口捷豹>>']\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口捷豹新能源>>']\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口路虎>>']\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口路虎新能源>>']\n",
    "\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LVT')|(all1['3']=='LVU')|(all1['3']=='LVV')|(all1['3']=='L2C')|(all1['3']=='LSJ')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CJL7201J1AW5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1915</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>1997</td>\n",
       "      <td>221</td>\n",
       "      <td>L2CBA3B3×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CJL7203J1A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1840</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>1997</td>\n",
       "      <td>184</td>\n",
       "      <td>L2CBB3BX×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CJL7200J1AW5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1905</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>1997</td>\n",
       "      <td>184</td>\n",
       "      <td>L2CBA3BX×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CJL7202J1A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1825</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>1997</td>\n",
       "      <td>147</td>\n",
       "      <td>L2CBB3B2×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CJL7202J1A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1825</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>1997</td>\n",
       "      <td>147</td>\n",
       "      <td>L2CBB3B2×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CJL7300J1A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1915</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>2995</td>\n",
       "      <td>250</td>\n",
       "      <td>L2CBB3BV×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CJL7203J1A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1840</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>1997</td>\n",
       "      <td>184</td>\n",
       "      <td>L2CBB3BX×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CJL7300J1A5</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>1915</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>2995</td>\n",
       "      <td>250</td>\n",
       "      <td>L2CBB3BV×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CJL7203J1A5</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>1840</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>1997</td>\n",
       "      <td>184</td>\n",
       "      <td>L2CBB3BX×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CJL7202J1A5</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>1825</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>1997</td>\n",
       "      <td>147</td>\n",
       "      <td>L2CBB3B2×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>CJL7300J1A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1915</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>2995</td>\n",
       "      <td>250</td>\n",
       "      <td>L2CBB3BV×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CJL7201J1A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1810</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>1999</td>\n",
       "      <td>177</td>\n",
       "      <td>L2CBB3BG×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CJL7200J1A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1795</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093</td>\n",
       "      <td>1880</td>\n",
       "      <td>1456</td>\n",
       "      <td>1999</td>\n",
       "      <td>147</td>\n",
       "      <td>L2CBB3BJ×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>3100</td>\n",
       "      <td>5093x1880x1456</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XFL</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>CJL7200J2A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1730</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788</td>\n",
       "      <td>1850</td>\n",
       "      <td>1429</td>\n",
       "      <td>1997</td>\n",
       "      <td>147</td>\n",
       "      <td>L2CAB3B2×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788x1850x1429</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XEL</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CJL7201J2A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1730</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788</td>\n",
       "      <td>1850</td>\n",
       "      <td>1429</td>\n",
       "      <td>1997</td>\n",
       "      <td>184</td>\n",
       "      <td>L2CAB3BX×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788x1850x1429</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XEL</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CJL7201J2A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1730</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788</td>\n",
       "      <td>1850</td>\n",
       "      <td>1429</td>\n",
       "      <td>1997</td>\n",
       "      <td>184</td>\n",
       "      <td>L2CAB3BX×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788x1850x1429</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XEL</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>CJL7200J2A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1730</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788</td>\n",
       "      <td>1850</td>\n",
       "      <td>1429</td>\n",
       "      <td>1997</td>\n",
       "      <td>147</td>\n",
       "      <td>L2CAB3B2×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788x1850x1429</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XEL</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CJL7201J2A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1730</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788</td>\n",
       "      <td>1850</td>\n",
       "      <td>1429</td>\n",
       "      <td>1997</td>\n",
       "      <td>184</td>\n",
       "      <td>L2CAB3BX×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788x1850x1429</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XEL</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CJL7200J2A5</td>\n",
       "      <td>捷豹(JAGUAR)</td>\n",
       "      <td>1730</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788</td>\n",
       "      <td>1850</td>\n",
       "      <td>1429</td>\n",
       "      <td>1997</td>\n",
       "      <td>147</td>\n",
       "      <td>L2CAB3B2×××××××××</td>\n",
       "      <td>奇瑞捷豹路虎汽车有限公司</td>\n",
       "      <td>L2C</td>\n",
       "      <td>2935</td>\n",
       "      <td>4788x1850x1429</td>\n",
       "      <td>捷豹</td>\n",
       "      <td>捷豹XEL</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>SQR7155J602</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>1278</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572</td>\n",
       "      <td>1825</td>\n",
       "      <td>1482</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LVVDC11B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVV</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572x1825x1482</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>艾瑞泽5</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>SQR7155J602</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>1278</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572</td>\n",
       "      <td>1825</td>\n",
       "      <td>1482</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LVVDC11B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVV</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572x1825x1482</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>艾瑞泽5</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>SQR7155J60T2</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>1321</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572</td>\n",
       "      <td>1825</td>\n",
       "      <td>1482</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LVVDC21B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVV</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572x1825x1482</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>艾瑞泽5</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>SQR7153J60T2</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>1297</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572</td>\n",
       "      <td>1825</td>\n",
       "      <td>1482</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LVVDC21B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVV</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572x1825x1482</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>艾瑞泽5</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>SQR7152J602</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>1335</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572</td>\n",
       "      <td>1825</td>\n",
       "      <td>1482</td>\n",
       "      <td>1498</td>\n",
       "      <td>108</td>\n",
       "      <td>LVVDC11B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVV</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572x1825x1482</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>艾瑞泽5</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>SQR7151J60T2</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>1265</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572</td>\n",
       "      <td>1825</td>\n",
       "      <td>1482</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LVVDC21B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVV</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572x1825x1482</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>艾瑞泽5</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>SQR7150J60T2</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>1297</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572</td>\n",
       "      <td>1825</td>\n",
       "      <td>1482</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LVVDC21B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVV</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572x1825x1482</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>艾瑞泽5</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>SQR7150J602</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>1265</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572</td>\n",
       "      <td>1825</td>\n",
       "      <td>1482</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LVVDC11B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVV</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572x1825x1482</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>艾瑞泽5</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>SQR7153J60T2</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>1297</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572</td>\n",
       "      <td>1825</td>\n",
       "      <td>1482</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LVVDC21B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVV</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572x1825x1482</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>艾瑞泽5</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>SQR7151J602</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>1229</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572</td>\n",
       "      <td>1825</td>\n",
       "      <td>1482</td>\n",
       "      <td>1499</td>\n",
       "      <td>85</td>\n",
       "      <td>LVVDC11B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVV</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572x1825x1482</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>艾瑞泽5</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>SQR7152J60T2</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>1372</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572</td>\n",
       "      <td>1825</td>\n",
       "      <td>1482</td>\n",
       "      <td>1498</td>\n",
       "      <td>108</td>\n",
       "      <td>LVVDC21B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVV</td>\n",
       "      <td>2670</td>\n",
       "      <td>4572x1825x1482</td>\n",
       "      <td>奇瑞</td>\n",
       "      <td>艾瑞泽5</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1137</th>\n",
       "      <td>SQR6470P117</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1882</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDB14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1138</th>\n",
       "      <td>SQR6470P11D7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1916</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1905</td>\n",
       "      <td>93</td>\n",
       "      <td>LVTDB15B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1139</th>\n",
       "      <td>SQR6470P117</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1882</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDB14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1140</th>\n",
       "      <td>SQR6471P11DA7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>2015</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1905</td>\n",
       "      <td>93</td>\n",
       "      <td>LVTDD15B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1141</th>\n",
       "      <td>SQR6470P11D7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1916</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1905</td>\n",
       "      <td>93</td>\n",
       "      <td>LVTDB15B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1142</th>\n",
       "      <td>SQR6470P11A7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1924</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDD14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1143</th>\n",
       "      <td>SQR6471P11DA7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>2015</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1905</td>\n",
       "      <td>93</td>\n",
       "      <td>LVTDD15B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1144</th>\n",
       "      <td>SQR6470P11A7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1924</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDD14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1145</th>\n",
       "      <td>SQR6470P11D7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1916</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1905</td>\n",
       "      <td>93</td>\n",
       "      <td>LVTDB15B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1146</th>\n",
       "      <td>SQR6470P11A7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1924</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDD14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1147</th>\n",
       "      <td>SQR6470P117</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1882</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDB14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1148</th>\n",
       "      <td>SQR6471P11DA7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>2015</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1905</td>\n",
       "      <td>93</td>\n",
       "      <td>LVTDD15B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1149</th>\n",
       "      <td>SQR6470P117</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1882</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDB14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1150</th>\n",
       "      <td>SQR6471P11DA7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>2015</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1905</td>\n",
       "      <td>93</td>\n",
       "      <td>LVTDD15B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1151</th>\n",
       "      <td>SQR6470P11A7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1924</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDD14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1152</th>\n",
       "      <td>SQR6470P11A7</td>\n",
       "      <td>威麟</td>\n",
       "      <td>1924</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697</td>\n",
       "      <td>1878</td>\n",
       "      <td>1836</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDD14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2725</td>\n",
       "      <td>4697x1878x1836</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟X5</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1153</th>\n",
       "      <td>SQR6540H137</td>\n",
       "      <td>威麟</td>\n",
       "      <td>2195</td>\n",
       "      <td>3110</td>\n",
       "      <td>5410</td>\n",
       "      <td>1920</td>\n",
       "      <td>2290</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDH14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>3110</td>\n",
       "      <td>5410x1920x2290</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟H5</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1154</th>\n",
       "      <td>SQR6540H137</td>\n",
       "      <td>威麟</td>\n",
       "      <td>2195</td>\n",
       "      <td>3110</td>\n",
       "      <td>5410</td>\n",
       "      <td>1920</td>\n",
       "      <td>2290</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDH14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>3110</td>\n",
       "      <td>5410x1920x2290</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟H5</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1155</th>\n",
       "      <td>SQR6540H137</td>\n",
       "      <td>威麟</td>\n",
       "      <td>2195</td>\n",
       "      <td>3110</td>\n",
       "      <td>5410</td>\n",
       "      <td>1920</td>\n",
       "      <td>2290</td>\n",
       "      <td>1971</td>\n",
       "      <td>125</td>\n",
       "      <td>LVTDH14B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>3110</td>\n",
       "      <td>5410x1920x2290</td>\n",
       "      <td>威麟</td>\n",
       "      <td>威麟H5</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1156</th>\n",
       "      <td>SQR6401S227</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>1165,1195,1195,1195</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040</td>\n",
       "      <td>1640</td>\n",
       "      <td>1900</td>\n",
       "      <td>1173</td>\n",
       "      <td>59</td>\n",
       "      <td>LVTDB12A×××××××××,LVTDB12B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040x1640x1900</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>开瑞优雅</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1157</th>\n",
       "      <td>SQR6400S220</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>1220,1250,1250,1250</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040</td>\n",
       "      <td>1640</td>\n",
       "      <td>1900</td>\n",
       "      <td>1297</td>\n",
       "      <td>61</td>\n",
       "      <td>LVTDB12A×××××××××,LVTDB12B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040x1640x1900</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>开瑞优雅</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1158</th>\n",
       "      <td>SQR6400S220</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>1220,1250,1250,1250</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040</td>\n",
       "      <td>1640</td>\n",
       "      <td>1900</td>\n",
       "      <td>1297</td>\n",
       "      <td>61</td>\n",
       "      <td>LVTDB12A×××××××××,LVTDB12B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040x1640x1900</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>开瑞优雅</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1159</th>\n",
       "      <td>SQR6401S227</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>1165,1195,1195,1195</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040</td>\n",
       "      <td>1640</td>\n",
       "      <td>1900</td>\n",
       "      <td>1173</td>\n",
       "      <td>59</td>\n",
       "      <td>LVTDB12A×××××××××,LVTDB12B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040x1640x1900</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>开瑞优雅</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1160</th>\n",
       "      <td>SQR6400S220</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>\"1220,1250,1250,1250\"</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040</td>\n",
       "      <td>1640</td>\n",
       "      <td>1900</td>\n",
       "      <td>1297</td>\n",
       "      <td>61</td>\n",
       "      <td>LVTDB12A×××××××××,LVTDB12B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040x1640x1900</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>开瑞优雅</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1161</th>\n",
       "      <td>SQR6401S227</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>\"1165,1195,1195,1195\"</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040</td>\n",
       "      <td>1640</td>\n",
       "      <td>1900</td>\n",
       "      <td>1173</td>\n",
       "      <td>59</td>\n",
       "      <td>LVTDB12A×××××××××,LVTDB12B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040x1640x1900</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>开瑞优雅</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1162</th>\n",
       "      <td>SQR6400S220</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>1220,1250,1250,1250</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040</td>\n",
       "      <td>1640</td>\n",
       "      <td>1900</td>\n",
       "      <td>1297</td>\n",
       "      <td>61</td>\n",
       "      <td>LVTDB12A×××××××××,LVTDB12B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040x1640x1900</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>开瑞优雅</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1163</th>\n",
       "      <td>SQR6401S227</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>1165,1195,1195,1195</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040</td>\n",
       "      <td>1640</td>\n",
       "      <td>1900</td>\n",
       "      <td>1173</td>\n",
       "      <td>59</td>\n",
       "      <td>LVTDB12A×××××××××,LVTDB12B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040x1640x1900</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>开瑞优雅</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1164</th>\n",
       "      <td>SQR6401S227</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>1165,1195,1195,1195</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040</td>\n",
       "      <td>1640</td>\n",
       "      <td>1900</td>\n",
       "      <td>1173</td>\n",
       "      <td>59</td>\n",
       "      <td>LVTDB12A×××××××××,LVTDB12B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040x1640x1900</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>开瑞优雅</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1165</th>\n",
       "      <td>SQR6401S226</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>1165,1195,1195,1195</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040</td>\n",
       "      <td>1640</td>\n",
       "      <td>1900</td>\n",
       "      <td>1173</td>\n",
       "      <td>59</td>\n",
       "      <td>LVTDB12A×××××××××,LVTDB12B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040x1640x1900</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>开瑞优雅</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1166</th>\n",
       "      <td>SQR6401S226</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>1165,1195,1195,1195</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040</td>\n",
       "      <td>1640</td>\n",
       "      <td>1900</td>\n",
       "      <td>1173</td>\n",
       "      <td>59</td>\n",
       "      <td>LVTDB12A×××××××××\\rLVTDB12B×××××××××</td>\n",
       "      <td>奇瑞汽车股份有限公司</td>\n",
       "      <td>LVT</td>\n",
       "      <td>2625</td>\n",
       "      <td>4040x1640x1900</td>\n",
       "      <td>开瑞</td>\n",
       "      <td>开瑞优雅</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1167 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        notice_type     brand_x            curb_weight Wheelbase car_length  \\\n",
       "0      CJL7201J1AW5  捷豹(JAGUAR)                   1915      3100       5093   \n",
       "1       CJL7203J1A5  捷豹(JAGUAR)                   1840      3100       5093   \n",
       "2      CJL7200J1AW5  捷豹(JAGUAR)                   1905      3100       5093   \n",
       "3       CJL7202J1A5  捷豹(JAGUAR)                   1825      3100       5093   \n",
       "4       CJL7202J1A5  捷豹(JAGUAR)                   1825      3100       5093   \n",
       "5       CJL7300J1A5  捷豹(JAGUAR)                   1915      3100       5093   \n",
       "6       CJL7203J1A5  捷豹(JAGUAR)                   1840      3100       5093   \n",
       "7       CJL7300J1A5          捷豹                   1915      3100       5093   \n",
       "8       CJL7203J1A5          捷豹                   1840      3100       5093   \n",
       "9       CJL7202J1A5          捷豹                   1825      3100       5093   \n",
       "10      CJL7300J1A5  捷豹(JAGUAR)                   1915      3100       5093   \n",
       "11      CJL7201J1A5  捷豹(JAGUAR)                   1810      3100       5093   \n",
       "12      CJL7200J1A5  捷豹(JAGUAR)                   1795      3100       5093   \n",
       "13      CJL7200J2A5  捷豹(JAGUAR)                   1730      2935       4788   \n",
       "14      CJL7201J2A5  捷豹(JAGUAR)                   1730      2935       4788   \n",
       "15      CJL7201J2A5  捷豹(JAGUAR)                   1730      2935       4788   \n",
       "16      CJL7200J2A5  捷豹(JAGUAR)                   1730      2935       4788   \n",
       "17      CJL7201J2A5  捷豹(JAGUAR)                   1730      2935       4788   \n",
       "18      CJL7200J2A5  捷豹(JAGUAR)                   1730      2935       4788   \n",
       "19      SQR7155J602          奇瑞                   1278      2670       4572   \n",
       "20      SQR7155J602          奇瑞                   1278      2670       4572   \n",
       "21     SQR7155J60T2          奇瑞                   1321      2670       4572   \n",
       "22     SQR7153J60T2          奇瑞                   1297      2670       4572   \n",
       "23      SQR7152J602          奇瑞                   1335      2670       4572   \n",
       "24     SQR7151J60T2          奇瑞                   1265      2670       4572   \n",
       "25     SQR7150J60T2          奇瑞                   1297      2670       4572   \n",
       "26      SQR7150J602          奇瑞                   1265      2670       4572   \n",
       "27     SQR7153J60T2          奇瑞                   1297      2670       4572   \n",
       "28      SQR7151J602          奇瑞                   1229      2670       4572   \n",
       "29     SQR7152J60T2          奇瑞                   1372      2670       4572   \n",
       "...             ...         ...                    ...       ...        ...   \n",
       "1137    SQR6470P117          威麟                   1882      2725       4697   \n",
       "1138   SQR6470P11D7          威麟                   1916      2725       4697   \n",
       "1139    SQR6470P117          威麟                   1882      2725       4697   \n",
       "1140  SQR6471P11DA7          威麟                   2015      2725       4697   \n",
       "1141   SQR6470P11D7          威麟                   1916      2725       4697   \n",
       "1142   SQR6470P11A7          威麟                   1924      2725       4697   \n",
       "1143  SQR6471P11DA7          威麟                   2015      2725       4697   \n",
       "1144   SQR6470P11A7          威麟                   1924      2725       4697   \n",
       "1145   SQR6470P11D7          威麟                   1916      2725       4697   \n",
       "1146   SQR6470P11A7          威麟                   1924      2725       4697   \n",
       "1147    SQR6470P117          威麟                   1882      2725       4697   \n",
       "1148  SQR6471P11DA7          威麟                   2015      2725       4697   \n",
       "1149    SQR6470P117          威麟                   1882      2725       4697   \n",
       "1150  SQR6471P11DA7          威麟                   2015      2725       4697   \n",
       "1151   SQR6470P11A7          威麟                   1924      2725       4697   \n",
       "1152   SQR6470P11A7          威麟                   1924      2725       4697   \n",
       "1153    SQR6540H137          威麟                   2195      3110       5410   \n",
       "1154    SQR6540H137          威麟                   2195      3110       5410   \n",
       "1155    SQR6540H137          威麟                   2195      3110       5410   \n",
       "1156    SQR6401S227          开瑞    1165,1195,1195,1195      2625       4040   \n",
       "1157    SQR6400S220          开瑞    1220,1250,1250,1250      2625       4040   \n",
       "1158    SQR6400S220          开瑞    1220,1250,1250,1250      2625       4040   \n",
       "1159    SQR6401S227          开瑞    1165,1195,1195,1195      2625       4040   \n",
       "1160    SQR6400S220          开瑞  \"1220,1250,1250,1250\"      2625       4040   \n",
       "1161    SQR6401S227          开瑞  \"1165,1195,1195,1195\"      2625       4040   \n",
       "1162    SQR6400S220          开瑞    1220,1250,1250,1250      2625       4040   \n",
       "1163    SQR6401S227          开瑞    1165,1195,1195,1195      2625       4040   \n",
       "1164    SQR6401S227          开瑞    1165,1195,1195,1195      2625       4040   \n",
       "1165    SQR6401S226          开瑞    1165,1195,1195,1195      2625       4040   \n",
       "1166    SQR6401S226          开瑞    1165,1195,1195,1195      2625       4040   \n",
       "\n",
       "     car_width car_height Displacement power  \\\n",
       "0         1880       1456         1997   221   \n",
       "1         1880       1456         1997   184   \n",
       "2         1880       1456         1997   184   \n",
       "3         1880       1456         1997   147   \n",
       "4         1880       1456         1997   147   \n",
       "5         1880       1456         2995   250   \n",
       "6         1880       1456         1997   184   \n",
       "7         1880       1456         2995   250   \n",
       "8         1880       1456         1997   184   \n",
       "9         1880       1456         1997   147   \n",
       "10        1880       1456         2995   250   \n",
       "11        1880       1456         1999   177   \n",
       "12        1880       1456         1999   147   \n",
       "13        1850       1429         1997   147   \n",
       "14        1850       1429         1997   184   \n",
       "15        1850       1429         1997   184   \n",
       "16        1850       1429         1997   147   \n",
       "17        1850       1429         1997   184   \n",
       "18        1850       1429         1997   147   \n",
       "19        1825       1482         1499    85   \n",
       "20        1825       1482         1499    85   \n",
       "21        1825       1482         1499    85   \n",
       "22        1825       1482         1499    85   \n",
       "23        1825       1482         1498   108   \n",
       "24        1825       1482         1499    85   \n",
       "25        1825       1482         1499    85   \n",
       "26        1825       1482         1499    85   \n",
       "27        1825       1482         1499    85   \n",
       "28        1825       1482         1499    85   \n",
       "29        1825       1482         1498   108   \n",
       "...        ...        ...          ...   ...   \n",
       "1137      1878       1836         1971   125   \n",
       "1138      1878       1836         1905    93   \n",
       "1139      1878       1836         1971   125   \n",
       "1140      1878       1836         1905    93   \n",
       "1141      1878       1836         1905    93   \n",
       "1142      1878       1836         1971   125   \n",
       "1143      1878       1836         1905    93   \n",
       "1144      1878       1836         1971   125   \n",
       "1145      1878       1836         1905    93   \n",
       "1146      1878       1836         1971   125   \n",
       "1147      1878       1836         1971   125   \n",
       "1148      1878       1836         1905    93   \n",
       "1149      1878       1836         1971   125   \n",
       "1150      1878       1836         1905    93   \n",
       "1151      1878       1836         1971   125   \n",
       "1152      1878       1836         1971   125   \n",
       "1153      1920       2290         1971   125   \n",
       "1154      1920       2290         1971   125   \n",
       "1155      1920       2290         1971   125   \n",
       "1156      1640       1900         1173    59   \n",
       "1157      1640       1900         1297    61   \n",
       "1158      1640       1900         1297    61   \n",
       "1159      1640       1900         1173    59   \n",
       "1160      1640       1900         1297    61   \n",
       "1161      1640       1900         1173    59   \n",
       "1162      1640       1900         1297    61   \n",
       "1163      1640       1900         1173    59   \n",
       "1164      1640       1900         1173    59   \n",
       "1165      1640       1900         1173    59   \n",
       "1166      1640       1900         1173    59   \n",
       "\n",
       "                                       vin   car_factory    3 轴距[mm]  \\\n",
       "0                        L2CBA3B3×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "1                        L2CBB3BX×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "2                        L2CBA3BX×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "3                        L2CBB3B2×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "4                        L2CBB3B2×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "5                        L2CBB3BV×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "6                        L2CBB3BX×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "7                        L2CBB3BV×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "8                        L2CBB3BX×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "9                        L2CBB3B2×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "10                       L2CBB3BV×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "11                       L2CBB3BG×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "12                       L2CBB3BJ×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   3100   \n",
       "13                       L2CAB3B2×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   2935   \n",
       "14                       L2CAB3BX×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   2935   \n",
       "15                       L2CAB3BX×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   2935   \n",
       "16                       L2CAB3B2×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   2935   \n",
       "17                       L2CAB3BX×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   2935   \n",
       "18                       L2CAB3B2×××××××××  奇瑞捷豹路虎汽车有限公司  L2C   2935   \n",
       "19                       LVVDC11B×××××××××    奇瑞汽车股份有限公司  LVV   2670   \n",
       "20                       LVVDC11B×××××××××    奇瑞汽车股份有限公司  LVV   2670   \n",
       "21                       LVVDC21B×××××××××    奇瑞汽车股份有限公司  LVV   2670   \n",
       "22                       LVVDC21B×××××××××    奇瑞汽车股份有限公司  LVV   2670   \n",
       "23                       LVVDC11B×××××××××    奇瑞汽车股份有限公司  LVV   2670   \n",
       "24                       LVVDC21B×××××××××    奇瑞汽车股份有限公司  LVV   2670   \n",
       "25                       LVVDC21B×××××××××    奇瑞汽车股份有限公司  LVV   2670   \n",
       "26                       LVVDC11B×××××××××    奇瑞汽车股份有限公司  LVV   2670   \n",
       "27                       LVVDC21B×××××××××    奇瑞汽车股份有限公司  LVV   2670   \n",
       "28                       LVVDC11B×××××××××    奇瑞汽车股份有限公司  LVV   2670   \n",
       "29                       LVVDC21B×××××××××    奇瑞汽车股份有限公司  LVV   2670   \n",
       "...                                    ...           ...  ...    ...   \n",
       "1137                     LVTDB14B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1138                     LVTDB15B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1139                     LVTDB14B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1140                     LVTDD15B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1141                     LVTDB15B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1142                     LVTDD14B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1143                     LVTDD15B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1144                     LVTDD14B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1145                     LVTDB15B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1146                     LVTDD14B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1147                     LVTDB14B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1148                     LVTDD15B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1149                     LVTDB14B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1150                     LVTDD15B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1151                     LVTDD14B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1152                     LVTDD14B×××××××××    奇瑞汽车股份有限公司  LVT   2725   \n",
       "1153                     LVTDH14B×××××××××    奇瑞汽车股份有限公司  LVT   3110   \n",
       "1154                     LVTDH14B×××××××××    奇瑞汽车股份有限公司  LVT   3110   \n",
       "1155                     LVTDH14B×××××××××    奇瑞汽车股份有限公司  LVT   3110   \n",
       "1156   LVTDB12A×××××××××,LVTDB12B×××××××××    奇瑞汽车股份有限公司  LVT   2625   \n",
       "1157   LVTDB12A×××××××××,LVTDB12B×××××××××    奇瑞汽车股份有限公司  LVT   2625   \n",
       "1158   LVTDB12A×××××××××,LVTDB12B×××××××××    奇瑞汽车股份有限公司  LVT   2625   \n",
       "1159   LVTDB12A×××××××××,LVTDB12B×××××××××    奇瑞汽车股份有限公司  LVT   2625   \n",
       "1160   LVTDB12A×××××××××,LVTDB12B×××××××××    奇瑞汽车股份有限公司  LVT   2625   \n",
       "1161   LVTDB12A×××××××××,LVTDB12B×××××××××    奇瑞汽车股份有限公司  LVT   2625   \n",
       "1162   LVTDB12A×××××××××,LVTDB12B×××××××××    奇瑞汽车股份有限公司  LVT   2625   \n",
       "1163   LVTDB12A×××××××××,LVTDB12B×××××××××    奇瑞汽车股份有限公司  LVT   2625   \n",
       "1164   LVTDB12A×××××××××,LVTDB12B×××××××××    奇瑞汽车股份有限公司  LVT   2625   \n",
       "1165   LVTDB12A×××××××××,LVTDB12B×××××××××    奇瑞汽车股份有限公司  LVT   2625   \n",
       "1166  LVTDB12A×××××××××\\rLVTDB12B×××××××××    奇瑞汽车股份有限公司  LVT   2625   \n",
       "\n",
       "           长×宽×高[mm] brand_y  style  factory  \n",
       "0     5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "1     5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "2     5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "3     5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "4     5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "5     5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "6     5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "7     5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "8     5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "9     5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "10    5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "11    5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "12    5093x1880x1456      捷豹  捷豹XFL       13  \n",
       "13    4788x1850x1429      捷豹  捷豹XEL        6  \n",
       "14    4788x1850x1429      捷豹  捷豹XEL        6  \n",
       "15    4788x1850x1429      捷豹  捷豹XEL        6  \n",
       "16    4788x1850x1429      捷豹  捷豹XEL        6  \n",
       "17    4788x1850x1429      捷豹  捷豹XEL        6  \n",
       "18    4788x1850x1429      捷豹  捷豹XEL        6  \n",
       "19    4572x1825x1482      奇瑞   艾瑞泽5       29  \n",
       "20    4572x1825x1482      奇瑞   艾瑞泽5       29  \n",
       "21    4572x1825x1482      奇瑞   艾瑞泽5       29  \n",
       "22    4572x1825x1482      奇瑞   艾瑞泽5       29  \n",
       "23    4572x1825x1482      奇瑞   艾瑞泽5       29  \n",
       "24    4572x1825x1482      奇瑞   艾瑞泽5       29  \n",
       "25    4572x1825x1482      奇瑞   艾瑞泽5       29  \n",
       "26    4572x1825x1482      奇瑞   艾瑞泽5       29  \n",
       "27    4572x1825x1482      奇瑞   艾瑞泽5       29  \n",
       "28    4572x1825x1482      奇瑞   艾瑞泽5       29  \n",
       "29    4572x1825x1482      奇瑞   艾瑞泽5       29  \n",
       "...              ...     ...    ...      ...  \n",
       "1137  4697x1878x1836      威麟   威麟X5       18  \n",
       "1138  4697x1878x1836      威麟   威麟X5       18  \n",
       "1139  4697x1878x1836      威麟   威麟X5       18  \n",
       "1140  4697x1878x1836      威麟   威麟X5       18  \n",
       "1141  4697x1878x1836      威麟   威麟X5       18  \n",
       "1142  4697x1878x1836      威麟   威麟X5       18  \n",
       "1143  4697x1878x1836      威麟   威麟X5       18  \n",
       "1144  4697x1878x1836      威麟   威麟X5       18  \n",
       "1145  4697x1878x1836      威麟   威麟X5       18  \n",
       "1146  4697x1878x1836      威麟   威麟X5       18  \n",
       "1147  4697x1878x1836      威麟   威麟X5       18  \n",
       "1148  4697x1878x1836      威麟   威麟X5       18  \n",
       "1149  4697x1878x1836      威麟   威麟X5       18  \n",
       "1150  4697x1878x1836      威麟   威麟X5       18  \n",
       "1151  4697x1878x1836      威麟   威麟X5       18  \n",
       "1152  4697x1878x1836      威麟   威麟X5       18  \n",
       "1153  5410x1920x2290      威麟   威麟H5       12  \n",
       "1154  5410x1920x2290      威麟   威麟H5       12  \n",
       "1155  5410x1920x2290      威麟   威麟H5       12  \n",
       "1156  4040x1640x1900      开瑞   开瑞优雅        3  \n",
       "1157  4040x1640x1900      开瑞   开瑞优雅        3  \n",
       "1158  4040x1640x1900      开瑞   开瑞优雅        3  \n",
       "1159  4040x1640x1900      开瑞   开瑞优雅        3  \n",
       "1160  4040x1640x1900      开瑞   开瑞优雅        3  \n",
       "1161  4040x1640x1900      开瑞   开瑞优雅        3  \n",
       "1162  4040x1640x1900      开瑞   开瑞优雅        3  \n",
       "1163  4040x1640x1900      开瑞   开瑞优雅        3  \n",
       "1164  4040x1640x1900      开瑞   开瑞优雅        3  \n",
       "1165  4040x1640x1900      开瑞   开瑞优雅        3  \n",
       "1166  4040x1640x1900      开瑞   开瑞优雅        3  \n",
       "\n",
       "[1167 rows x 17 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price =LSG_price.drop([41])\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('奇瑞.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
